HW#3 --- last modified January 01 1970 00:00:00..

Solution set.

Due date: Mar 20

Files to be submitted:
  Ch5Ch6Probs.doc
  StudentDB.sql
  Section.ctl
  Section.dat
  Section.log

Purpose: To gain familiarity with database data storage. To use the Oracle bulk loader.

Specification:

Turn in problems 5.23, 5.27, 6.14, 6.15 out of E&N. Then write an SQL script (a sequence of SQL commands stored in a file) StudentDB.sql to create the tables in figure 1.2 on page 7 of E&N. Do not insert any of the row data into these tables yet. The SQL command to create tables is CREATE TABLE. Information on and examples of this command can be found from Dr. Sathaye's Introduction of Oracle. This same reference has examples of DROP TABLE, the SQL command to get rid of a table in case you want to retest your script. To execute the SQL script called scriptname.sql in SQLPLUS use @scriptname. Once you have created these tables your task will be to populate the SECTION table as on page 7 using the Oracle Bulk Loader. The Bulk Loader can be run from the Unix prompt with the command sqlldr. There are instructions on how to use the bulk loader in the file: K:\sathaye\oracle\howtoguides\Orbulkload at school. Section.ctl should be your control file which will say how the loading is done. The file Section.dat should contain the data for the table in question. Finally, Section.log should be the log file you got from actually doing the loading.

Point Breakdown